Exercise: COUNTIF, SUMIF

In this exercise, you'll practice using the aggregation functions from the demo, COUNTIF and SUMIF. The data set will be similar too, except the names and teams are different because your exercise set, ALbb_salaries_2003.csv, is the American League Baseball salaries from 2003.

Task Description:

The following list has a series of steps for this exercise. As you complete each step, check it off the list. The quizzes in the task list can be found below.

Task Feedback:

Congratulations!

COUNTIF Category

QUESTION:

How many pitchers are on the roster?

ANSWER:

SOLUTION:

NOTE: The solutions are expressed in RegEx pattern. Udacity uses these patterns to check the given answer

COUNTIF Numerical

QUESTION:

How many players in the roster have a salary over $10,000,000?

ANSWER:

SOLUTION:

NOTE: The solutions are expressed in RegEx pattern. Udacity uses these patterns to check the given answer

SUMIF

QUESTION:

How much money was spent in the league on salaries over $10,000,000?

ANSWER:

SOLUTION:

NOTE: The solutions are expressed in RegEx pattern. Udacity uses these patterns to check the given answer